Requirement already satisfied: squarify in /home/pela/.local/lib/python3.8/site-packages (0.4.3)
/home/pela/Documents/ayush/customer_segm_RFM
Out[4]:
InvoiceNo StockCode Description Quantity InvoiceDate UnitPrice CustomerID Country
0 536365 85123A WHITE HANGING HEART T-LIGHT HOLDER 6 01-12-2010 08:26 2.55 17850.0 United Kingdom
1 536365 71053 WHITE METAL LANTERN 6 01-12-2010 08:26 3.39 17850.0 United Kingdom
2 536365 84406B CREAM CUPID HEARTS COAT HANGER 8 01-12-2010 08:26 2.75 17850.0 United Kingdom
3 536365 84029G KNITTED UNION FLAG HOT WATER BOTTLE 6 01-12-2010 08:26 3.39 17850.0 United Kingdom
4 536365 84029E RED WOOLLY HOTTIE WHITE HEART. 6 01-12-2010 08:26 3.39 17850.0 United Kingdom
... ... ... ... ... ... ... ... ...
994 536520 22092 BLUE PAISLEY TISSUE BOX 1 01-12-2010 12:43 1.25 14729.0 United Kingdom
995 536520 22469 HEART OF WICKER SMALL 1 01-12-2010 12:43 1.65 14729.0 United Kingdom
996 536520 22100 SKULLS SQUARE TISSUE BOX 1 01-12-2010 12:43 1.25 14729.0 United Kingdom
997 536520 22096 PINK PAISLEY SQUARE TISSUE BOX 1 01-12-2010 12:43 1.25 14729.0 United Kingdom
998 536520 22583 PACK OF 6 HANDBAG GIFT BOXES 1 01-12-2010 12:43 2.55 14729.0 United Kingdom

999 rows × 8 columns

Out[6]:
Timestamp('2010-01-12 12:43:00')
Out[7]:
InvoiceNo              object
StockCode              object
Description            object
Quantity                int64
InvoiceDate    datetime64[ns]
UnitPrice             float64
CustomerID            float64
Country                object
dtype: object
2011-12-10 00:00:00
Out[10]:
InvoiceNo StockCode Description Quantity InvoiceDate UnitPrice CustomerID Country TotalSum Frequency
0 536365 85123A WHITE HANGING HEART T-LIGHT HOLDER 6 2010-01-12 08:26:00 2.55 17850.0 United Kingdom 15.30 696 days 15:34:00
1 536365 71053 WHITE METAL LANTERN 6 2010-01-12 08:26:00 3.39 17850.0 United Kingdom 20.34 696 days 15:34:00
2 536365 84406B CREAM CUPID HEARTS COAT HANGER 8 2010-01-12 08:26:00 2.75 17850.0 United Kingdom 22.00 696 days 15:34:00
3 536365 84029G KNITTED UNION FLAG HOT WATER BOTTLE 6 2010-01-12 08:26:00 3.39 17850.0 United Kingdom 20.34 696 days 15:34:00
4 536365 84029E RED WOOLLY HOTTIE WHITE HEART. 6 2010-01-12 08:26:00 3.39 17850.0 United Kingdom 20.34 696 days 15:34:00
... ... ... ... ... ... ... ... ... ... ...
994 536520 22092 BLUE PAISLEY TISSUE BOX 1 2010-01-12 12:43:00 1.25 14729.0 United Kingdom 1.25 696 days 11:17:00
995 536520 22469 HEART OF WICKER SMALL 1 2010-01-12 12:43:00 1.65 14729.0 United Kingdom 1.65 696 days 11:17:00
996 536520 22100 SKULLS SQUARE TISSUE BOX 1 2010-01-12 12:43:00 1.25 14729.0 United Kingdom 1.25 696 days 11:17:00
997 536520 22096 PINK PAISLEY SQUARE TISSUE BOX 1 2010-01-12 12:43:00 1.25 14729.0 United Kingdom 1.25 696 days 11:17:00
998 536520 22583 PACK OF 6 HANDBAG GIFT BOXES 1 2010-01-12 12:43:00 2.55 14729.0 United Kingdom 2.55 696 days 11:17:00

999 rows × 10 columns

Recency¶

Reference Date: 2011-12-10 00:00:00
Out[11]:
count mean std min 25% 50% 75% max
CustomerID 48.0 15558.083333 1842.620669 12431.0 13755.5 15687.5 17442.75 18085.0
recency 48.0 696.000000 0.000000 696.0 696.0 696.0 696.00 696.0
Out[12]:
CustomerID recency
0 12431.0 696.0
1 12583.0 696.0
2 12791.0 696.0
3 12838.0 696.0
4 13047.0 696.0
5 13255.0 696.0
6 13408.0 696.0
7 13448.0 696.0
8 13694.0 696.0
9 13705.0 696.0
10 13747.0 696.0
11 13748.0 696.0
12 13758.0 696.0
13 13767.0 696.0
14 14045.0 696.0
15 14307.0 696.0
16 14527.0 696.0
17 14688.0 696.0
18 14729.0 696.0
19 14849.0 696.0
20 15100.0 696.0
21 15291.0 696.0
22 15311.0 696.0
23 15513.0 696.0
24 15862.0 696.0
25 15983.0 696.0
26 16029.0 696.0
27 16098.0 696.0
28 16210.0 696.0
29 16218.0 696.0
30 16250.0 696.0
31 16552.0 696.0
32 16583.0 696.0
33 17181.0 696.0
34 17377.0 696.0
35 17420.0 696.0
36 17511.0 696.0
37 17548.0 696.0
38 17809.0 696.0
39 17850.0 696.0
40 17897.0 696.0
41 17908.0 696.0
42 17920.0 696.0
43 17924.0 696.0
44 17951.0 696.0
45 17968.0 696.0
46 18074.0 696.0
47 18085.0 696.0

Frequency¶

Monetary Value¶

Out[16]:
CustomerID recency frequency TotalSum
0 12431.0 696.0 1 358.25
1 12583.0 696.0 1 855.86
2 12791.0 696.0 1 192.60
3 12838.0 696.0 1 390.79
4 13047.0 696.0 3 366.63
5 13255.0 696.0 1 225.70
6 13408.0 696.0 1 1024.68
7 13448.0 696.0 2 443.96
8 13694.0 696.0 1 842.12
9 13705.0 696.0 1 318.14
10 13747.0 696.0 1 79.60
11 13748.0 696.0 1 204.00
12 13758.0 696.0 1 362.45
13 13767.0 696.0 1 507.88
14 14045.0 696.0 1 326.40
15 14307.0 696.0 1 783.11
16 14527.0 696.0 1 -27.50
17 14688.0 696.0 1 444.98
18 14729.0 696.0 1 265.87
19 14849.0 696.0 3 355.84
20 15100.0 696.0 1 350.40
21 15291.0 696.0 1 328.80
22 15311.0 696.0 2 445.33
23 15513.0 696.0 1 357.00
24 15862.0 696.0 1 354.23
25 15983.0 696.0 1 440.89
26 16029.0 696.0 2 3702.12
27 16098.0 696.0 1 430.60
28 16210.0 696.0 1 2474.74
29 16218.0 696.0 1 471.30
30 16250.0 696.0 1 226.14
31 16552.0 696.0 1 95.29
32 16583.0 696.0 1 233.45
33 17181.0 696.0 1 155.52
34 17377.0 696.0 1 223.90
35 17420.0 696.0 1 130.85
36 17511.0 696.0 1 1825.74
37 17548.0 696.0 1 -141.48
38 17809.0 696.0 1 34.80
39 17850.0 696.0 10 1499.34
40 17897.0 696.0 2 140.39
41 17908.0 696.0 1 243.28
42 17920.0 696.0 1 514.41
43 17924.0 696.0 1 279.00
44 17951.0 696.0 1 295.50
45 17968.0 696.0 1 277.35
46 18074.0 696.0 1 489.60
47 18085.0 696.0 1 303.90
Out[18]:
CustomerID    0
Recency       0
Frequency     0
Monetary      0
dtype: int64
Out[20]:
CustomerID Recency Frequency Monetary
0 12431.0 696.0 1 358.25
1 12583.0 696.0 1 855.86
2 12791.0 696.0 1 192.60
3 12838.0 696.0 1 390.79
4 13047.0 696.0 3 366.63
5 13255.0 696.0 1 225.70
6 13408.0 696.0 1 1024.68
7 13448.0 696.0 2 443.96
8 13694.0 696.0 1 842.12
9 13705.0 696.0 1 318.14
10 13747.0 696.0 1 79.60
11 13748.0 696.0 1 204.00
12 13758.0 696.0 1 362.45
13 13767.0 696.0 1 507.88
14 14045.0 696.0 1 326.40
15 14307.0 696.0 1 783.11
16 14527.0 696.0 1 -27.50
17 14688.0 696.0 1 444.98
18 14729.0 696.0 1 265.87
19 14849.0 696.0 3 355.84
20 15100.0 696.0 1 350.40
21 15291.0 696.0 1 328.80
22 15311.0 696.0 2 445.33
23 15513.0 696.0 1 357.00
24 15862.0 696.0 1 354.23
25 15983.0 696.0 1 440.89
26 16029.0 696.0 2 3702.12
27 16098.0 696.0 1 430.60
28 16210.0 696.0 1 2474.74
29 16218.0 696.0 1 471.30
30 16250.0 696.0 1 226.14
31 16552.0 696.0 1 95.29
32 16583.0 696.0 1 233.45
33 17181.0 696.0 1 155.52
34 17377.0 696.0 1 223.90
35 17420.0 696.0 1 130.85
36 17511.0 696.0 1 1825.74
37 17548.0 696.0 1 -141.48
38 17809.0 696.0 1 34.80
39 17850.0 696.0 10 1499.34
40 17897.0 696.0 2 140.39
41 17908.0 696.0 1 243.28
42 17920.0 696.0 1 514.41
43 17924.0 696.0 1 279.00
44 17951.0 696.0 1 295.50
45 17968.0 696.0 1 277.35
46 18074.0 696.0 1 489.60
47 18085.0 696.0 1 303.90